********************************************************************************
*																			   *
*						Sir! I'd Rather Go to School Sir!					   *
*																			   *
*								 Mahdi Majbouri								   *
*																			   *
*									 Table A3								   *
*																			   *
*									6-6-2023								   *
*																			   *
********************************************************************************


use "census11-all.dta", clear

keep if fage>=fage18 & fage18>=threshold - 9 & fage18<=threshold + 10


*** Regressions for father's education
regress father_ed t fa tfa if relate==3 & son==1 & sons == 1 & fage>=fage18 & urban == 2 & college_plus !=. & father_ed != . & mom_ed != .& mage !=., robust
outreg2 using "Table A3", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("FatherEd-p1") replace

regress father_ed t fa tfa fasq tfasq if relate==3 & son==1 & sons == 1 & fage>=fage18 & urban == 2 & college_plus !=. & father_ed != . & mom_ed != .& mage !=., robust
outreg2 using "Table A3", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("FatherEd-p2") append

regress father_ed t fa tfa fasq tfasq facb tfacb if relate==3 & son==1 & sons == 1 & fage>=fage18 & urban == 2 & college_plus !=. & father_ed != . & mom_ed != .& mage !=., robust
outreg2 using "Table A3", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("FatherEd-p3") append

				
*** Regressions for mother's education
regress mom_ed t fa tfa if relate==3 & son==1 & sons == 1 & fage>=fage18 & urban == 2 & college_plus !=. & father_ed != . & mom_ed != .& mage !=.
outreg2 using "Table A3", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("MotherEd-p1") append

regress mom_ed t fa tfa fasq tfasq if relate==3 & son==1 & sons == 1 & fage>=fage18 & urban == 2 & college_plus !=. & father_ed != . & mom_ed != .& mage !=.
outreg2 using "Table A3", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("MotherEd-p2") append

regress mom_ed t fa tfa fasq tfasq facb tfacb if relate==3 & son==1 & sons == 1 & fage>=fage18 & urban == 2 & college_plus !=. & father_ed != . & mom_ed != .& mage !=.
outreg2 using "Table A3", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("MotherEd-p3") append



*** Regressions for father's age
regress fage t fa tfa if relate==3 & son==1 & sons == 1 & fage>=fage18 & urban == 2 & college_plus !=. & father_ed != . & mom_ed != .& mage !=.
outreg2 using "Table A3", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("FatherAge-p1") append

regress fage t fa tfa fasq tfasq if relate==3 & son==1 & sons == 1 & fage>=fage18 & urban == 2 & college_plus !=. & father_ed != . & mom_ed != .& mage !=.
outreg2 using "Table A3", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("FatherAge-p2") append

regress fage t fa tfa fasq tfasq facb tfacb if relate==3 & son==1 & sons == 1 & fage>=fage18 & urban == 2 & college_plus !=. & father_ed != . & mom_ed != .& mage !=.
outreg2 using "Table A3", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("FatherAge-p3") append


*** Regressions for mother's age
regress mage t fa tfa if relate==3 & son==1 & sons == 1 & fage>=fage18 & urban == 2 & college_plus !=. & father_ed != . & mom_ed != .& mage !=.
outreg2 using "Table A3", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("MotherAge-p1") append

regress mage t fa tfa fasq tfasq if relate==3 & son==1 & sons == 1 & fage>=fage18 & urban == 2 & college_plus !=. & father_ed != . & mom_ed != .& mage !=.
outreg2 using "Table A3", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("MotherAge-p2") append

regress mage t fa tfa fasq tfasq facb tfacb if relate==3 & son==1 & sons == 1 & fage>=fage18 & urban == 2 & college_plus !=. & father_ed != . & mom_ed != .& mage !=.
outreg2 using "Table A3", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("MotherAge-p3") append


		
		
********************************************************************************
*********************************  THE END *************************************
********************************************************************************
